package com.example.mapper;

import com.example.pojo.Dept;
import com.example.pojo.Result;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DataMapper {
    //查询所有部门
//    @Results({
//            @Result(column = "create_time",property = "createTime"),
//            @Result(column = "update_time",property = "updateTime")
//
//    })
//    @Select("select id,name,create_time createTime,update_time updateTime from dept order by update_time desc")
    @Select("select id,name,create_time ,update_time  from dept order by update_time desc")
    List<Dept> findAll();

    //删除部门数据
    @Delete("delete  from dept where id =#{id}")
    public void delete(Integer id);

    //添加部门数据
    @Insert("insert into dept(name,create_time ,update_time) values (#{name},#{createTime},#{updateTime})")
    public void add(Dept dept);

    //查询部门数据
    @Select("select id, name, create_time, update_time from dept where id = #{id}")
    public Dept select(Integer id);

    //修改部门数据
   @Update("update dept set name = #{name},update_time =#{updateTime} where id = #{id}")
    public void update(Dept dept);
}
